Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_9918

R_9918

PhStDocTradeDocRelType

PhLStDocTradeDoc

StDocTradeDocRelTypeID

 

 

R_9919

R_9919

PhStDoc

PhDeliveryReturn

fromStDocId

 

 

R_9920

R_9920

PhStDoc

PhDeliveryReturn

toStDocId

 

 

R_9921

R_9921

PhStOrder

PhDeliveryReturn

StOrderId

 

 

R_9922

R_9922

PhStDoc

PhLStDocLimitRealization

StDocID

 

 

R_9927

R_9927

PhTradeDoc

PhLTradeDoc

CorrectedTradeDocID

 

 

R_9938

R_9938

PhLimitRealization

PhLStDocLimitRealization

LimitRealizationID

 

 

R_9941

R_9941

PhTradeDoc

PhLTradeDoc

TradeDocID

 

 

R_9946

R_9946

PhTenderOffer

PhTenderOfferFile

TenderOfferID

 

 

R_9976

R_9976

PhDrugReactionClass

PhDrugReactionClassText

DrugReactionClassID

 

 

R_9977

R_9977

PhDrugReactionClass

PhDrugReaction

DrugReactionClassID

 

 

R_9978

R_9978

Event

PhDrugReaction

EventID

 

 

R_9979

R_9979

PhLot

PhDrugReaction

LotID

 

 

R_10012

R_10012

PhTenderOfferStatus

PhTenderOfferStatusText

TenderOfferStatusId

 

 

R_10013

R_10013

PhTenderOfferStatus

PhTenderOffer

TenderOfferStatusId

 

 

R_10041

R_10041

PhTenderOfferKind

PhTenderOfferKindText

TenderOfferKindId

 

 

R_10042

R_10042

PhTenderOfferKind

PhTenderOffer

TenderOfferKindId

 

 

R_10045

R_10045

PhStOrderKind

PhStOrderKindText

StOrderKindID

 

 

R_10046

R_10046

PhStOrderKind

PhStOrder

StOrderKindID

 

 

R_10090

R_10090

PhStDocItem

PHLStOrderItemDrugLosses

StDocItemID

 

 

R_10091

R_10091

PhStOrderItem

PHLStOrderItemDrugLosses

StOrderItemID

 

 

R_10114

R_10114

PhTenderOfferType

PhTenderOfferTypeText

TenderOfferTypeID

 

 

R_10115

R_10115

PhStItem

PhOrderRealization

TenderOfferStockItemID

 

 

R_10135

R_10135

PhStKind

PhStKindText

StKindID

 

 

R_10136

R_10136

PhStKind

PhSt

StKindID

 

 

R_10163

R_10163

PhStItem

PhAuctionPackageItem

StItemID

 

 

R_10169

R_10169

PhTimePeriod

PhAuction

PaymentPeriodUnitID

 

 

R_10170

R_10170

PhTimePeriod

PhAuction

RealizationPeriodUnitID

 

 

R_10219

R_10219

PhLotPart

PhLotInStockPart

LotPartID

 

 

R_10220

R_10220

PhStItem

PhStItemPart

StItemID

 

 

R_10221

R_10221

PhLotInSt

PhLotInStockPart

LotInStID

 

 

R_10222

R_10222

PhStItemPart

PhLotPart

StItemPartID

 

 

R_10223

R_10223

PhLot

PhLotPart

LotId

 

 

R_10224

R_10224

PhLotPart

PhStDocItem

LotPartID

 

 

R_10241

R_10241

PhImportApp

PhLImportAppPatient

ImportAppID

 

 

R_10249

R_10249

PhP4Company

PhCompany

P4COMPANYID

 

 

R_10250

R_10250

PhImportDrugStatus

PhImportDrugStatusText

ImportDrugStatusID

 

 

R_10251

R_10251

PhImportDrug

PhImportDrugAttr

ImportDrugID

 

 

R_10252

R_10252

PhStItem

PhImportDrug

StItemID

 

 

R_10253

R_10253

PhDrug

PhImportDrug

DrugID

 

 

R_10254

R_10254

PhPack

PhImportDrug

PackID

 

 

R_10255

R_10255

PhImportDrugStatus

PhImportDrug

ImportDrugStatusID

 

 

R_10261

R_10261

PhBlockadeType

PhBlockadeTypeText

BlockadeTypeID

 

 

R_10262

R_10262

PhBlockadeType

PhBlockade

BlockadeTypeID

 

 

R_10350

R_10350

PhLotVerifiStatus

PhLot

LotVerifiStatusID

 

 

R_10351

R_10351

PhLotVerifiStatus

PhLotVerifiStatusText

LotVerifiStatusID

 

 

R_10352

R_10352

PhLotWithdrawalType

PhLotWithdrawalTypeText

LotWithdrawalTypeID

 

 

R_10353

R_10353

PhLotSNVerifiStatus

PhLotSNVerifiStatusText

LotSNVerifiStatusID

 

 

R_10354

R_10354

PhLot

PhLotSerialNumberVerifi

LotID

 

 

R_10355

R_10355

PhLotSNVerifiStatus

PhLotSerialNumberVerifi

LotSNVerifiStatusID

 

 


1  2  3  4  5  6  7  8